﻿CREATE TABLE [dbo].[OrderLineItemLiveBackup_Tbl] (
    [OrderLineItemID]          INT           NOT NULL,
    [OrderID]                  INT           NULL,
    [LineItem]                 INT           NULL,
    [QuoteSailTypeID]          INT           NULL,
    [Luff]                     FLOAT         NULL,
    [LporFoot]                 FLOAT         NULL,
    [InputArea]                FLOAT         NULL,
    [GenericYarnID]            INT           NULL,
    [BoatSpeed]                FLOAT         NULL,
    [AWS]                      INT           NULL,
    [FilmTypeID]               INT           NULL,
    [DPIID]                    INT           NULL,
    [CurrencyID]               INT           NULL,
    [Discount]                 FLOAT         NULL,
    [TierID]                   INT           NULL,
    [UsageID]                  INT           NULL,
    [CreateDate]               NVARCHAR (50) NULL,
    [ConstructionID]           INT           NULL,
    [Price]                    FLOAT         NULL,
    [SailModelCode]            NVARCHAR (50) NULL,
    [Cut]                      NVARCHAR (50) NULL,
    [Weight]                   NVARCHAR (50) NULL,
    [Multiple]                 INT           NULL,
    [TotalPrice]               FLOAT         NULL,
    [TotalOfferedPrice]        FLOAT         NULL,
    [AccessoryID]              INT           NULL,
    [PreDiscountPrice]         FLOAT         NULL,
    [SailNumber]               NVARCHAR (50) NULL,
    [SailNumberColourID]       INT           NULL,
    [SailMeasureID]            INT           NULL,
    [AccessoryColourID]        INT           NULL,
    [NylonColourDetails]       INT           NULL,
    [BRP]                      FLOAT         NULL,
    [FabricID]                 INT           NULL,
    [NotionalArea]             BIT           NULL,
    [TopSurfaceID]             INT           NULL,
    [BotSurfaceID]             INT           NULL,
    [AccessoryItemID]          INT           NULL,
    [Scheduled]                BIT           NULL,
    [DKKPrice]                 FLOAT         NULL,
    [DeliveryWeek]             INT           NULL,
    [DesignFile]               NVARCHAR (50) NULL,
    [BillingPrice]             FLOAT         NULL,
    [BillingDiscount]          FLOAT         NULL,
    [BillingCurrency]          NVARCHAR (50) NULL,
    [AxItem]                   NVARCHAR (50) NULL,
    [MarketPriceEuro]          FLOAT         NULL,
    [MarketRetailPrice]        FLOAT         NULL,
    [SeasonalPriceEuro]        FLOAT         NULL,
    [SeasonalPriceCurr]        FLOAT         NULL,
    [OptionTotal]              FLOAT         NULL,
    [COM]                      FLOAT         NULL,
    [ImportToProdCard]         BIT           NULL,
    [GenSailTypeID]            INT           NULL,
    [FurlingUnitID]            INT           NULL,
    [Window]                   BIT           NULL,
    [WindowSize]               INT           NULL,
    [WindowV1]                 INT           NULL,
    [WindowV2]                 INT           NULL,
    [MGT]                      INT           NULL,
    [MGU]                      INT           NULL,
    [MGM]                      INT           NULL,
    [MGL]                      INT           NULL,
    [TackID]                   INT           NULL,
    [TackCutback]              INT           NULL,
    [TackCutUp]                INT           NULL,
    [ReefCutback]              INT           NULL,
    [BoltRopeTotalID]          INT           NULL,
    [MastSliderTypeID]         INT           NULL,
    [BattenSliderType]         NVARCHAR (50) NULL,
    [Reef1Height]              INT           NULL,
    [Reef2Height]              INT           NULL,
    [Reef3Height]              INT           NULL,
    [ReefEyelet]               BIT           NULL,
    [FootStyleID]              INT           NULL,
    [BoomSliderID]             INT           NULL,
    [FoilEndTack]              INT           NULL,
    [FoilEndTop]               INT           NULL,
    [HeightSailInput]          INT           NULL,
    [HanksID]                  INT           NULL,
    [TotalFoilDiamID]          INT           NULL,
    [TackSystemID]             INT           NULL,
    [Notes]                    NTEXT         NULL,
    [TopFilmID]                INT           NULL,
    [BotFilmID]                INT           NULL,
    [1Reef]                    BIT           NULL,
    [2RReef]                   BIT           NULL,
    [2CReef]                   BIT           NULL,
    [3Reef]                    BIT           NULL,
    [SailLuff]                 INT           NULL,
    [SailLeech]                INT           NULL,
    [SailFoot]                 INT           NULL,
    [IsLeech]                  BIT           NULL,
    [SailLP]                   INT           NULL,
    [CutLuff]                  INT           NULL,
    [CutLeech]                 INT           NULL,
    [CutFoot]                  INT           NULL,
    [CutLP]                    INT           NULL,
    [RuleLuff]                 INT           NULL,
    [RuleLeech]                INT           NULL,
    [RuleFoot]                 INT           NULL,
    [RuleLP]                   INT           NULL,
    [SailGirth78]              INT           NULL,
    [SailGirth34]              INT           NULL,
    [SailGirth12]              INT           NULL,
    [SailGirth14]              INT           NULL,
    [CutGirth78]               INT           NULL,
    [CutGirth34]               INT           NULL,
    [CutGirth12]               INT           NULL,
    [CutGirth14]               INT           NULL,
    [RuleGirth78]              INT           NULL,
    [RuleGirth34]              INT           NULL,
    [RuleGirth12]              INT           NULL,
    [RuleGirth14]              INT           NULL,
    [SailSMW]                  INT           NULL,
    [SailSMG]                  INT           NULL,
    [CutSMW]                   INT           NULL,
    [CutSMG]                   INT           NULL,
    [RuleSMW]                  INT           NULL,
    [RuleSMG]                  INT           NULL,
    [UVColour]                 NVARCHAR (15) NULL,
    [UVSide]                   NVARCHAR (15) NULL,
    [InsigniaColourID]         INT           NULL,
    [TrimStripeColourID]       INT           NULL,
    [OriginatingOEMSailListID] INT           NULL,
    [NotArea]                  FLOAT         NULL,
    [FurlingUnitSupplierID]    INT           NULL,
    [IsFoot]                   BIT           NULL,
    [ProductionNumber]         NVARCHAR (50) NULL,
    [DepartmentID]             INT           NULL,
    [TotalCalcHrs]             FLOAT         NULL,
    [WorkProgressID]           INT           NULL,
    [StartProdWeek]            INT           NULL,
    [StartProdYear]            INT           NULL,
    [BackColor]                INT           NULL,
    [LocaleID]                 INT           NULL,
    [HeadLayoutID]             INT           NULL,
    [IsHardware]               BIT           NULL,
    [DeliveryDate]             DATETIME      NULL,
    [LuffDeduction]            INT           NULL,
    [LeechDeduction]           INT           NULL,
    [FootDeduction]            INT           NULL,
    [LPDeduction]              INT           NULL,
    [LuffFactor]               INT           NULL,
    [LuffHeadAttachment]       INT           NULL,
    [LuffTackAttachment]       INT           NULL,
    [SlideHankOffset]          INT           NULL,
    [ForestayLength]           INT           NULL,
    [MaxHoist]                 INT           NULL,
    [SailMeasurementID]        INT           NULL,
    [Halted]                   INT           NULL,
    [QuoteLineItemID]          INT           NULL,
    [AttachedToLineItem]       INT           NULL,
    [HasAttachment]            BIT           NULL
);

